package com.time.sky.mapper;

import com.time.sky.entity.DCJF;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface CDJFMapper {
    @Select("SELECT * FROM DCJF ")
    List<DCJF> selectList();
    @Insert("insert into DCJF(zrf,rqf,rubbish,gbenf,yajin,dbgtf,sbgtf) " +
            "values(#{zrf},#{rqf},#{rubbish},#{gbenf},#{yajin},#{dbgtf},#{sbgtf})")
    void add(DCJF dcjf);
    @Delete("delete from DCJF where did=#{did}")
    void delete(int did);
    @Select("SELECT * FROM DCJF  where did=#{did}")
    DCJF getById(int did);
    @Update("update DCJF set zrf=#{zrf},rqf=#{rqf},rubbish=#{rubbish},gbenf=#{gbenf},yajin=#{yajin},dbgtf=#{dbgtf},sbgtf=#{sbgtf} where did=#{did}")
    void update(DCJF dcjf);
}
